From 9957e2a849e2563d0315bdeba6a734f1d2e9ca7e Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 21 Jul 2026 22:17:44 +0000 Subject: [PATCH] Fix so update triggers fire only on update --- db/schemas/lib/triggers/create/chimps_on_tikis.m4 | 2 +- .../lib/triggers/create/community_membership_update_log.m4 | 2 +- db/schemas/lib/triggers/create/food_variations.m4 | 2 +- db/schemas/lib/triggers/create/pantgrunt_event_log.m4 | 2 +- db/schemas/lib/triggers/create/siv_status_bout.m4 | 2 +- db/schemas/lib/triggers/create/subadult_arrivals_log.m4 | 2 +- db/schemas/lib/triggers/create/tlk_brecord_notes_codes.m4 | 2 +- 7 files changed, 7 insertions(+), 7 deletions(-) diff --git a/db/schemas/lib/triggers/create/chimps_on_tikis.m4 b/db/schemas/lib/triggers/create/chimps_on_tikis.m4 index ca75825..2139d9f 100644 --- a/db/schemas/lib/triggers/create/chimps_on_tikis.m4 +++ b/db/schemas/lib/triggers/create/chimps_on_tikis.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'chimps_on_tikis_update_trigger'; CREATE TRIGGER chimps_on_tikis_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON chimps_on_tikis FOR EACH ROW EXECUTE PROCEDURE chimps_on_tikis_update_func(); diff --git a/db/schemas/lib/triggers/create/community_membership_update_log.m4 b/db/schemas/lib/triggers/create/community_membership_update_log.m4 index e232efb..bb53c29 100644 --- a/db/schemas/lib/triggers/create/community_membership_update_log.m4 +++ b/db/schemas/lib/triggers/create/community_membership_update_log.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'community_membership_update_log_update_trigger'; CREATE TRIGGER community_membership_update_log_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON community_membership_update_log FOR EACH ROW EXECUTE PROCEDURE community_membership_update_log_update_func(); diff --git a/db/schemas/lib/triggers/create/food_variations.m4 b/db/schemas/lib/triggers/create/food_variations.m4 index 1cc9869..4999ae6 100644 --- a/db/schemas/lib/triggers/create/food_variations.m4 +++ b/db/schemas/lib/triggers/create/food_variations.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'food_variations_update_trigger'; CREATE TRIGGER food_variations_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON food_variations FOR EACH ROW EXECUTE PROCEDURE food_variations_update_func(); diff --git a/db/schemas/lib/triggers/create/pantgrunt_event_log.m4 b/db/schemas/lib/triggers/create/pantgrunt_event_log.m4 index ffc00ab..e9f1227 100644 --- a/db/schemas/lib/triggers/create/pantgrunt_event_log.m4 +++ b/db/schemas/lib/triggers/create/pantgrunt_event_log.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'pantgrunt_event_log_update_trigger'; CREATE TRIGGER pantgrunt_event_log_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON pantgrunt_event_log FOR EACH ROW EXECUTE PROCEDURE pantgrunt_event_log_update_func(); diff --git a/db/schemas/lib/triggers/create/siv_status_bout.m4 b/db/schemas/lib/triggers/create/siv_status_bout.m4 index 0ed49a7..a9f2173 100644 --- a/db/schemas/lib/triggers/create/siv_status_bout.m4 +++ b/db/schemas/lib/triggers/create/siv_status_bout.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'siv_status_bout_update_trigger'; CREATE TRIGGER siv_status_bout_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON siv_status_bout FOR EACH ROW EXECUTE PROCEDURE siv_status_bout_update_func(); diff --git a/db/schemas/lib/triggers/create/subadult_arrivals_log.m4 b/db/schemas/lib/triggers/create/subadult_arrivals_log.m4 index 9961267..6042cd9 100644 --- a/db/schemas/lib/triggers/create/subadult_arrivals_log.m4 +++ b/db/schemas/lib/triggers/create/subadult_arrivals_log.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'subadult_arrivals_log_update_trigger'; CREATE TRIGGER subadult_arrivals_log_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON subadult_arrivals_log FOR EACH ROW EXECUTE PROCEDURE subadult_arrivals_log_update_func(); diff --git a/db/schemas/lib/triggers/create/tlk_brecord_notes_codes.m4 b/db/schemas/lib/triggers/create/tlk_brecord_notes_codes.m4 index 66c22d9..b1d96d6 100644 --- a/db/schemas/lib/triggers/create/tlk_brecord_notes_codes.m4 +++ b/db/schemas/lib/triggers/create/tlk_brecord_notes_codes.m4 @@ -44,6 +44,6 @@ $$; RAISE INFO 'tlk_brecord_notes_codes_update_trigger'; CREATE TRIGGER tlk_brecord_notes_codes_update_trigger - AFTER INSERT OR UPDATE + AFTER UPDATE ON tlk_brecord_notes_codes FOR EACH ROW EXECUTE PROCEDURE tlk_brecord_notes_codes_update_func(); -- 2.34.1